package com.example.finaltool.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.finaltool.model.db.SysCorp;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author dengbw
 */
@Mapper
public interface SysCorpMapper extends BaseMapper<SysCorp> {

    @Select("SELECT * FROM sys_corp WHERE province_id IS NULL OR city_id IS NULL OR district_id IS NULL OR village_id IS NULL;")
    List<SysCorp> getNull();
}
